<html>
    <head>
        <script src="//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script> 
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    </head>
    <body>
        <?php
        require_once 'model/db.php';
        ?>
        <h1> Nguyen Thanh Thien </h1>
        <?php
        $query = "SELECT * FROM companies";
        $companies = getData($query);
        $query = "SELECT * FROM apps";
        $apps = getData($query);
        ?>
        <form method="POST">
            Max fans<input type="text" name="max_fans" id ="max_fans" value="10"><br>
            Min fans<input type="text" name="min_fans" id ="mix_fans" value="1"><br>
            Keyword <input type="text" name="keyword" value="cafe"><br>
            Company<select name="id_company">
                <option value="0">-----------</option>
                <?php foreach ($companies as $company): ?>
                    <option value="<?php echo $company['id'] ?>"><?php echo $company['name'] ?></option>
                <?php endforeach; ?>
            </select>

            Application :<select name="id_apps">
                <option value="0">---------</option>
                <?php foreach ($apps as $app): ?>
                    <option value="<?php echo $app['id'] ?>"><?php echo $app['name'] ?></option>
                <?php endforeach; ?>
            </select>

            <input type="submit" name="submit">
             <input type="submit" name="check" id="check">
        </form>

        <?php if (isset($_POST['submit'])): ?>
            <?php
            $max_fans = $_POST['max_fans']; //TODO
            $min_fans = $_POST['min_fans']; //TODO
            $keyword = $_POST['keyword']; //TODO
            $company = $_POST["id_company"];
            $apps = $_POST["id_apps"];
            if (!empty($company))
                $company = "companies.id=$company AND";
            else
                $company = "";
            if (!empty($apps))
                $apps = "apps.id='$apps' AND";
            else
                $apps = "";



            if (empty($max_fans) && !empty($min_fans)) {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps 
                  pages.likes>= $min_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
            } else if (!empty($max_fans) && empty($min_fans)) {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.likes<= $max_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
            } else if (empty($max_fans) && empty($min_fans)) {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
            } else {
                $query = "SELECT * FROM pages
            INNER JOIN apps_pages ON pages.id=apps_pages.id_page
            INNER JOIN apps ON apps.id=apps_pages.id_app
            INNER JOIN companies ON companies.id=apps.id_company
            where $company
                  $apps
                  pages.likes>= $min_fans and
                  pages.likes<= $max_fans and
                  pages.description LIKE '% $keyword %'
                  LIMIT 0,10";
            }


            var_dump($query);

            $pages = getData($query);
            ?>

            <?php if (!empty($pages)): ?>
                <table>
                    <tr>
                        <td> profile </td>
                        <td> likes </td>
                        <td> Company </td>

                        <td> description </td>

                    </tr>
        <?php foreach ($pages as $page): ?>
                        <tr>
                            <td><img src="<?php echo $page['picture'] ?>"></td>
                            <td><?php echo $page['likes'] ?></td>
                            <td><?php echo $page['name'] ?></td>
                            <td><?php echo substr($page["description"], 0, 100); ?></td>
            <?php // var_dump($page);die(); ?>
                        </tr>
                    <?php endforeach; ?>
                </table> 

    <?php endif; ?>
<?php endif; ?>
        <script>
        $(document).ready(function (){
            $('#check').click(function (){
                var min_fans=$('min_fans').val();
                if($.isNumeric(min_fans)){
                }else{
                    alert('is not number');
                }
            });
        });
        </script>
        <script type="text/javascript">
            var txt = document.getElementById("Min_fans").value;
            var flag =checkNumber (min_fans);
            if(flag){
                alert('is number');
            }else{
                alert('is not number');
            }
            if(flag){
                alert('is not number ');   
            }
            alert('min_fans' + txt);
        </script>
        <script type="text/javascript">
            alert('helo ChiChaRiTo');
        </script>
        <script>
            $("#min_fans").click(function() {
                alert($("#min_fans").val());
            });
           function checkNumber(val){
               if($isNumberic(val)){
                   return true;
               }else{
                   return false;
               }
           }
                </script>

    </body>
    
</html>